{{extend 'layout.html'}}
{{block sectionclass}}shell{{end}}
<!-- begin "shell" block -->
<div id="wrapper">
	<div class="row-fluid">
		<div class="output-wrapper span8">
			<textarea id="output" readonly="readonly">web2py Shell {{=request.env.web2py_version}}</textarea>
		</div>
	</div>

	<div class="row-fluid">
		<form id="form" action="{{=URL(r=request,f='callback',args=app)}}" method="get" class="span8">
			<div id="shellwrapper">
				<div class="prompt-wrapper">
					<div class="prompt-container">
						<textarea class="prompt" name="statement" id="statement"></textarea>
					</div>
					<a href="#" rel="tooltip" data-placement="right" data-original-title="{{=T('Type some Python code in here and hit Return (Enter) to execute it.')}}">
						{{=helpicon()}}
						<span>Type some Python code in here and hit Return (Enter) to execute it.</span>
					</a>
				</div>
				<div id="caret"><span>&gt;&gt;&gt;</span></div>
				<div id="autoscroll">autoscroll</div>
			</div>
		</form>
	</div>

	<div class="row-fluid clearfix">
		<div class="help alert alert-info span6">
		  <ul>
			<li>Using the shell may lock the database to other users of this app.</li>
			<li>Each db statement is automatically committed.</li>
			<li>Creating new tables dynamically is not allowed.</li>
			<li>Models are automatically imported in the shell.</li>
		  </ul>
		</div>
	</div>
</div>
<script type="text/javascript" src="{{=URL('static', 'js/autoscroll.js')}}"></script>

<script type="text/javascript">
var bShellScrolling=0
jQuery(document).ready(function(){
  jQuery('#statement').focus();

  jQuery('#statement').keyup(function(event){
    var t=jQuery(this),
    s=t.val(),
    o=jQuery('#output'),
    RETURN = 38;
    if(s=='\n') t.val('');
    if(s.length>1 && s.substr(s.length-1,1)=='\n' && s.substr(s.length-2,1)!=':' &&
    (s.indexOf(':\n ')<0 || s.substr(s.length-2,1)=='\n')) {
      t.val('');
      jQuery.post("{{=URL(r=request,f='callback',args=app)}}",
      {statement:s},function(data){o.html(o.html()+data).attr('scrollTop',o.attr('scrollHeight'));});
    } else { };
    if(event.keyCode==RETURN){
      var i=s.length
      if(i==0){
        var s=o.find('table:last pre:first').text();
        bShellScrolling=o.find('table').length;
      }else if(bShellScrolling){
        var i=bShellScrolling
        if(i<1){
          return
        }else{
          i--
          var s=o.find('table:nth-child('+(i)+') pre:first').text();
          bShellScrolling=i
        }
      }else if(s.indexOf('\n')<0){
        var oo=o.find('tr:first-child pre:contains("'+s+'")')
        if(oo.length==0){
          return
        }else if(oo.length==1){
          s=oo.text();
        }else{
          sVar=oo.text();
          o.html(o.html()+'<dd>'+s+' ?</dd><dt>'+sVar+'</dt>').attr('scrollTop',o.attr('scrollHeight'))
          return
        }
      }else{
        //multistring expr
        return;
      }
      //  if(s.slice(s.length-1)=='\n'){
      s=s.slice(0,s.length-1)
      //	}
      t.val(s);
    }
    if(bShellScrolling && event.keyCode==40){
      var i=bShellScrolling
      i++
      var s=o.find('table:nth-child('+i+') tr:first-child pre').text();
      if(s){
        s=s.slice(0,s.length-1)
        t.val(s);
        bShellScrolling=i
      }else{
        bShellScrolling=0
        t.val('')
      }
    };
    if(bShellScrolling && (event.keyCode==37 || event.keyCode==39)){
      bShellScrolling=0;
    };
    if(event.keyCode==27){
      bShellScrolling=0;
      t.val('');
    };
  });
});
</script>
<!-- end "shell" block -->